Description:

As an MIS Analyst at CRED, you will be responsible for designing, developing, and maintaining regular and ad-hoc reports that track key performance indicators (KPIs). You will write and optimize SQL queries to extract data from relational databases and manipulate datasets using advanced Excel features such as pivot tables, formulas, and macros.

Building dashboards and visual presentations, identifying data discrepancies, performing data quality checks, and troubleshooting data integrity issues will be part of your routine. You will collaborate closely with business stakeholders across operations, finance, and sales to gather reporting requirements and convert them into actionable and accurate reports.

You will streamline and automate reporting processes to minimize manual work, document report definitions, data sources, and calculation logic, and support forecasting and variance analyses while ensuring data security and confidentiality as per company policies.

Key Technical Skills:

SQL, Microsoft Excel (pivot tables, advanced formulas, macros/VBA), Data Reporting, Data Visualization, Data Quality, ETL Processes, Dashboard Building

Requirements:

• Bachelor’s degree in Information Systems, Computer Science, Finance, Statistics, Business Analytics, or related field
• Proven experience (1-3 years or more for senior roles) in MIS reporting, data analysis, or analyst roles
• Strong proficiency in SQL for complex queries, joins, and aggregate functions
• Advanced Excel skills including pivot tables, LOOKUPs, INDEX/MATCH, IF conditions, and macros/VBA (preferred)
• Strong analytical thinking with a keen eye for patterns and data anomalies
• Understanding of business processes and ability to translate technical data into meaningful business insights
• Excellent communication skills to present insights and collaborate with non-technical stakeholders
• Ability to manage multiple reports under deadlines and prioritize tasks effectively